select * from Pupil where age = 4
select * from Pupil where age > 4
select * from Pupil where age < 8
select * from Pupil where age <> 6
select * from Pupil where age in (5,6)
select * from Pupil where age between 4 and 6


select * from Pupil
select * from Pupil where name = 'ABC'
select * from Pupil where name = 'abc'

select * from Pupil where email = 'abc@school.com';

select * from Pupil where email = 'abc@school.com    ';
select * from Pupil where email = '    abc@school.com';
select * from Pupil where email = 'abc@school.com.';

--Get data where email Id is available.
select * from Pupil where email is not null	--Correct
select * from Pupil where email <> null	--Incorrect

--Get data where email Id is unavailable
select * from Pupil where email is null	--Correct
select * from Pupil where email = null	--Incorrect
select * from Pupil where email in (null) --Incorrect

select * from Pupil where name in ('ABC', 'DEF')

select * from Pupil 
select * from Pupil where name between 'a' and 'd' --Names starting with a,b,c
select * from Pupil where name between 'a' and 'e' --Names starting with a,b,c,d
select * from Pupil where name between 'a' and 'f' --Names starting with a,b,c,d,e	
select * from Pupil where name between 'd' and 'd'
select * from Pupil where name between 'd' and 'e'

select * from pupil
--Distinct - Non repeated values in a column. No duplicates. Unique values.
select gender from pupil
select distinct gender from pupil
select distinct name  from pupil

--Distinct nature will be evaluated on the given column  values combination.
select distinct name,gender from pupil

--Wild card characters using like key word
--Student names starting with letter 'a'
select * from pupil where name like 'a%'

--Student records whose grade ends with 'G'
select * from pupil where grade like '%G'

-- % - Any kind of character (0-9, a-z, A-Z, Special characters)

--Get All students whose grade containing letter K in it's value.
select * from pupil where grade like '%K%'